Trial Balance

Trial Balance showing the balances of the loans as of the date requested (or Current Balance if current balances selected.) The Trial Date must be a date for which the Accrual Processing has been completed.

Field	Description
Selections
Contact Number	Contact number for which to run the report. When populated, Contact Number Starting and Contact Number Ending are disabled.
Contact Number Starting	Starting number of the range of contacts for which to run the report. When populated, Contact Number is disabled.
Contact Number Ending	Ending number of the range of contacts for which to run the report. When populated, Contact Number is disabled.
Contact Entity	The contact's entity type.
Contact Portfolio	The contact portfolio or contact type.
Loan Number	Loan number for which to run the report. When populated, Loan Number Starting and Loan Number Ending are disabled.
Loan Number Starting	Starting number of the range of loans for which to run the report. When populated, Loan Number is disabled.
Loan Number Ending	Ending number of the range of loans for which to run the report. When populated, Loan Number is disabled.
Loan Portfolio	The loan portfolio associated with the loan.
Loan Type	Type of loan.
Loan Status	The status of the loan.
Status Code	The status code assigned to the loan. Ignore Status code is not used in the search criteria. Include Loans with the selected status code is specifically included in the search result. Exclude Loans with selected status code is specifically excluded from the search result.
Loan Group	Loan group associated with the loan.
Loan Class	Loan class assigned to the loan. Any match in Class 1 or Class 2 will be included in the report.
Loan Officer	The officer assigned to the loan.
Collection Officer	Collection officer assigned to the contact.
Risk Rating	Risk rating of the loan.
Branch	Records belonging to the selected branch will be included in the report.
Dealers	Contacts with entity type of organization.
Commitments	Loans with loan type of commitment.
Interest Type	Only loans with the selected interest types are included in the report. Available selections: All SI – Simple Interest AD – Average Daily Balance FA – Fixed Amortization FB – Fixed Amortization (Beginning) 78 – Rule of 78s - Add On 7S – Rule of 78s - Simple
Trial Date	Loans with this trial date will be included in the report.
Balances To Use	The type of balance to use from the Trial Date.
Name To Use	Specify the name field displayed in the report.
Past Due Days From
Past Due Days To
Sort Type	Specifies the ascending or descending sort order of the Sort By sorting field.
Include Loans	When selected, non-participated loans are included in the report.
Include Participations	When selected, participated loans are included in the report.
Include Participants	When selected, participant pieces of loans are included in the report.
Participants to Include	The selected types (All, Primary, Non-primary) of participant peices are included in the report., non-participated loans are included in the report.
Include Zero Balance Loans	When selected, loans with zero balance are included in the report.
Show 2 Places	When selected, applicable data will be truncated to display two decimal places.
Show Totals Only	When selected, only the totals lines are included in the report.
Consolidated Layout
Grouping
Group By 1/Page Break	Output is grouped by the selected field. When the checkbox is selected, new groupings start on a new page.
Group By 2/Page Break	Output is grouped by the selected field within the Group By 1 grouping. When the checkbox is selected, new groupings start on a new page.
Group By 3/Page Break
Group By 4/Page Break
Sorting
Sort By	Output of reports will be sorted in ascending order of the selected field.
Output
Report Output	Output type or format of the generated report.
Fields To Include	Excel CSV Click to choose which fields to include in the Excel output.